﻿CREATE PROCEDURE dbo.SP_MemberAddresses_Insert
	@AppartmentNumber NChar (10)  =  NULL 
		, @BuildingNumber NChar (10)  =  NULL 
		, @Directions NVarChar (Max)  =  NULL 
		, @FloorNumber NChar (10)  =  NULL 
		, @MemberId Int   =  NULL 
		, @Street NVarChar (256)  =  NULL 
		, @ZipCode NChar (10)  =  NULL 
		AS
			INSERT INTO MemberAddresses
			(
									AppartmentNumber
												,BuildingNumber
												,Directions
												,FloorNumber
												,MemberId
												,Street
												,ZipCode
									)
			Values(
									@AppartmentNumber
												,@BuildingNumber
												,@Directions
												,@FloorNumber
												,@MemberId
												,@Street
												,@ZipCode
						)
			return @@identity